﻿/********************************************************************************************************************
* Author:	Aris Michail																							*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_addEntity" that adds an				*
*			entity to a category.																					*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_addEntity]
	@categoryid bigint,
	@entityname nvarchar(50)
AS
	INSERT INTO Entities
	VALUES(@categoryid,@entityname,'0')

RETURN 0